﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Rpt_hr_employee.aspx.cs" Inherits="ZX.WebApp.rpt.Rpt_hr_employee" %>

<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div style="width: 21cm; height: 29.7cm;">
    
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
            Font-Size="8pt" InteractiveDeviceInfos="(集合)" WaitMessageFont-Names="Verdana" 
            WaitMessageFont-Size="14pt" Height="29.7cm" Width="21cm">
            <localreport reportpath="rpt\FinallyRpt.rdlc">
                <datasources>
                    <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSourcehrEmployeeExperiences" 
                        Name="hrEmployeeExperiences" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSourcehrEmployeeFamily" 
                        Name="hrEmployeeFamily" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSourcehrEmployeeRecommend" 
                        Name="hrEmployeeRecommend" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSourcehrEmployeeGuarantee" 
                        Name="hrEmployeeGuarantee" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSourcehrEmployeeAdjustPost" 
                        Name="hrEmployeeAdjustPost" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSourcehrEmployeeSanction" 
                        Name="hrEmployeeSanction" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSourcehrEmployeePaymentInfo" 
                        Name="hrEmployeePaymentInfo" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSourcehrEmployeeFileStreams" 
                        Name="DataSet2" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSourcehrEmployeeTrainings" 
                        Name="hrEmployeeTrainings" />
                </datasources>
            </localreport>
        </rsweb:ReportViewer>
        <br />
        
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnString %>" 
            SelectCommand="SELECT * FROM [V_hrEmployee] WHERE id = @uid">
            <SelectParameters>
            <asp:QueryStringParameter Name="uid" QueryStringField="id" />
            </SelectParameters>
            </asp:SqlDataSource>

            
        <asp:SqlDataSource ID="SqlDataSourcehrEmployeeExperiences" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnString %>" 
            SelectCommand="SELECT * FROM [hrEmployeeExperiences] WHERE EmployeeID = @uid">
            <SelectParameters>
            <asp:QueryStringParameter Name="uid" QueryStringField="id" />
            </SelectParameters>
            </asp:SqlDataSource>

            
        <asp:SqlDataSource ID="SqlDataSourcehrEmployeeFamily" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnString %>" 
            SelectCommand="SELECT * FROM [hrEmployeeFamily] WHERE EmployeeID = @uid">
            <SelectParameters>
            <asp:QueryStringParameter Name="uid" QueryStringField="id" />
            </SelectParameters>
            </asp:SqlDataSource>


            
        <asp:SqlDataSource ID="SqlDataSourcehrEmployeeRecommend" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnString %>" 
            SelectCommand="SELECT * FROM [hrEmployeeRecommend] WHERE EmployeeID = @uid">
            <SelectParameters>
            <asp:QueryStringParameter Name="uid" QueryStringField="id" />
            </SelectParameters>
            </asp:SqlDataSource>

            
        <asp:SqlDataSource ID="SqlDataSourcehrEmployeeGuarantee" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnString %>" 
            SelectCommand="SELECT * FROM [hrEmployeeGuarantee] WHERE EmployeeID = @uid">
            <SelectParameters>
            <asp:QueryStringParameter Name="uid" QueryStringField="id" />
            </SelectParameters>
            </asp:SqlDataSource>
            
        <asp:SqlDataSource ID="SqlDataSourcehrEmployeeAdjustPost" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnString %>" 
            SelectCommand="SELECT * FROM [hrEmployeeAdjustPost] WHERE EmployeeID = @uid">
            <SelectParameters>
            <asp:QueryStringParameter Name="uid" QueryStringField="id" />
            </SelectParameters>
            </asp:SqlDataSource>
            
        <asp:SqlDataSource ID="SqlDataSourcehrEmployeeSanction" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnString %>" 
            SelectCommand="SELECT * FROM [hrEmployeeSanction] WHERE EmployeeID = @uid">
            <SelectParameters>
            <asp:QueryStringParameter Name="uid" QueryStringField="id" />
            </SelectParameters>
            </asp:SqlDataSource>

            
        <asp:SqlDataSource ID="SqlDataSourcehrEmployeePaymentInfo" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnString %>" 
            SelectCommand="SELECT * FROM [hrEmployeePaymentInfo] WHERE EmployeeID = @uid">
            <SelectParameters>
            <asp:QueryStringParameter Name="uid" QueryStringField="id" />
            </SelectParameters>
            </asp:SqlDataSource>

            
        <asp:SqlDataSource ID="SqlDataSourcehrEmployeeFileStreams" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnString %>" 
            SelectCommand="SELECT * FROM [hrEmployeeFileStreams] WHERE datstate=0 and  Precordid = @uid">
            <SelectParameters>
            <asp:QueryStringParameter Name="uid" QueryStringField="id" />
            </SelectParameters>
            </asp:SqlDataSource>

            
        <asp:SqlDataSource ID="SqlDataSourcehrEmployeeTrainings" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnString %>" 
            SelectCommand="SELECT * FROM [hrEmployeeTrainings] WHERE EmployeeID = @uid">
            <SelectParameters>
            <asp:QueryStringParameter Name="uid" QueryStringField="id" />
            </SelectParameters>
            </asp:SqlDataSource>

        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
    
    
    </div>
    </form>
</body>
</html>
